/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost
 Source Database       : travel

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : utf-8

 Date: 09/03/2018 22:14:09 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `order_type`
-- ----------------------------
DROP TABLE IF EXISTS `order_type` ;
CREATE TABLE `order_type` (
  `order_type_id` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '订单名称',
  `icon` varchar(255) DEFAULT NULL COMMENT '订单图标',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`order_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单种类表';

-- ----------------------------
--  Records of `order_type`
-- ----------------------------
BEGIN;
INSERT INTO `order_type` VALUES ('0001', '火车票订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551858044310194.file?Expires=1850878580&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=Jqz3eA7tR6XeJ6rfgvDKdH1l%2B%2Fo%3D', '2018-08-28 17:35:57'), ('0002', '机票订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551820113310282.file?Expires=1850878201&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=qPgCtoCELc9YLnOzKC5zbsMeH1U%3D', '2018-08-28 17:36:09'), ('0003', '酒店订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551823149810113.file?Expires=1850878231&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=ZjR8cuGWKCr5HvSdb%2Bslq8D7tRA%3D', '2018-08-28 17:36:15'), ('0004', '终点房订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551825102310391.file?Expires=1850878251&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=H8demLiAy3nNgfYpAKk92%2FEXK0g%3D', '2018-08-28 17:36:21'), ('0005', '酒店团购订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551831452310745.file?Expires=1850878314&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=nJK9pQdxnFFU8B6rpL4NSvRoO3s%3D', '2018-08-28 17:36:42'), ('0006', '门票订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551834128910811.file?Expires=1850878341&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=c6ErHpr2BB4SFWp3bUHjunI4iX4%3D', '2018-08-28 17:36:52'), ('0007', '汽车票订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551836100910615.file?Expires=1850878361&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=dptqmBMjo7qQ%2FM6vCSjSv3MsQek%3D', '2018-08-28 17:37:07'), ('0008', '接送机订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551836100910615.file?Expires=1850878361&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=dptqmBMjo7qQ%2FM6vCSjSv3MsQek%3D', '2018-08-28 17:37:21'), ('0009', '车车订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551840062210419.file?Expires=1850878400&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=YqZDhiXN9IKlfViefhPYaJ%2Ftatk%3D', '2018-08-28 17:37:28'), ('0010', '度假订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551842143210310.file?Expires=1850878421&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=A9yr7F48yebIhCDXneOkdx7QhUs%3D', '2018-08-28 17:37:36'), ('0011', '公寓订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551842143210310.file?Expires=1850878421&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=A9yr7F48yebIhCDXneOkdx7QhUs%3D', '2018-08-28 17:38:59'), ('0012', '导游WI-FI订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551847822110056.file?Expires=1850878478&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=6Uxr7w984TJGQ5Dp%2F13HWxl1tvc%3D', '2018-08-28 17:39:28'), ('0013', '景区直通车订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551849931210098.file?Expires=1850878499&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=bOWL3%2Fn6V4%2FMGMSZZIUSHZ7U5%2BY%3D', '2018-08-28 17:39:34'), ('0014', 'Q城订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551851343110663.file?Expires=1850878513&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=7V8wCO2xL2P4dIJVHIKpnBIZeAQ%3D', '2018-08-28 17:39:38'), ('0015', '美食订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551880985510849.file?Expires=1850878809&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=No5yMyYXx1BPnpcxJkPRSbbLCxk%3D', '2018-08-28 17:39:42'), ('0016', '电影票订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551882681610332.file?Expires=1850878826&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=%2BkMC3IAjazSRdF3eeV1MXMBqtqg%3D', '2018-08-28 17:39:47'), ('0017', '保险订单', 'http://travelproject.oss-cn-hangzhou.aliyuncs.com/travelfolder153551884408210221.file?Expires=1850878844&OSSAccessKeyId=LTAIY32ReEvm2zAS&Signature=XU%2BdUoeI5t49SedC4%2Fden07%2BVYg%3D', '2018-08-28 17:39:54');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
